package manager.msales;

import java.io.*;
import common.db.*;
import common.main.*;

public class GoodsFindBean extends MainBean
{
	public void funcExecute() throws Exception
	{
		String name = (String)inputTable.get("productName");

		queryBuffer = new StringBuffer("");
		queryBuffer.append("SELECT GOODS.SEQ, GOODS.NAME, GOODS_IMAGE.PATH FROM GOODS, GOODS_IMAGE WHERE GOODS.SEQ = GOODS_IMAGE.GOODS_SEQ(+) AND GOODS.NAME LIKE '%"+name+"%'");

		DBExecute dbe = new DBExecute(queryBuffer.toString());
		outputList = dbe.getDataList();
	}
}